package com.fjnldx.ks.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Component;


@Component
@Mapper
public interface CommonMapper {
    @Select("select password from user where username=#{username} limit 0,1")
    String getPassword(String username);
    @Select("select role from user where username=#{username} limit 0,1")
    String getRole(String username);
    @Select("select uuidKs uuid from user where username=#{username}")
    String getUserUuid(String username);
    @Update("UPDATE user set uuidKs = #{uuid} WHERE username=#{username}")
    void updateUserUuid(String username,String uuid);
}
